Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “friller” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
friller10411174(None) 
driller84311881driller
filler94623621f_iller
frilled113911601frilled
frillers11349871frillers
frillier1136511frillier
griller84513351griller
triller74215891triller
biller84923482_biller
brailler1036882brailler
bridler103811072bridler
chiller124112182chiller
cruller968752cruller
drilled94711672drilled
drillers9429722drillers
droller84110282droller
eviller1056672eviller
faille93414742faille_
failles102914132failles
faller94621232f_aller
feller94419552f_eller
filer85433002f_i_ler
fille84327402f_ille_
filled104922262f_illed
fillers104320212f_illers
filles94224522f_illes
fillet95027082f_illet
filmer114112402f_ilmer
filter94517632f_ilter
frailer10319942frailer
fribbler15265952fribbler
frier85225842fri__er
frill84917562frill__
frills94414222frill_s
frilly124111442frill_y
frisker14389272frisker
fritter103912772fritter
frivoler1443932frivoler
frivoller1542432frivoller
frizer184011282fri_zer
frizzer18446892frizzer
frizzler19345842frizzler
fueller10279962fueller
fuller94220382f_uller
giller74519732_giller
grille74315742grille_
grilled94012832grilled
grillers93810812grillers
grillery12355502grillery
grilles83715022grilles
hiller94421632_hiller
iller54821292__iller
killer104917952_killer
kruller1145152kruller
miller84625412_miller
prilled104713002prilled
rifler94014262_rifler
rille55728732_rille_
rilled74525652_rilled
rilles64725502_rilles
rillet64828852_rillet
roller63919792_roller
shriller1136822shriller
siller64026062_siller
spiller92914332spiller
stiller73414292stiller
swiller103211662swiller
thriller1165552thriller
tiller64222542_tiller
trifler103912152trifler
trilled84116312trilled
trillers83613492trillers
troller73913172troller
willer94021062_willer

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911076710.373479064.3
2DLD Change Limit107671743.17333933.5
3Display Results74740.0461608.7
 (SQL Overall)178691743.59249746.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.