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 “filar” 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.

99 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
filar8481929(None) 
fiar76427331fi_ar
fila74729131fila_
filer85433001filer
hilar85418141hilar
pilar75221501pilar
alar46340072_alar
bifilar1244042bifilar
bolar75123472bolar
cigar8911802cigar
dinar66319892dinar
far67762602f__ar
fear75337792f_ear
feuar8310242feuar
fiars86720832fi_ars
fiat76646642fi_at
fiber104921132fiber
fibular12267972fibular
fifer115519972fifer
fil65447142fil__
filaree10611212filaree
filaria1039652filaria
filch134813322filch
file75446642fil_e
filed95331902filed
filers94623722filers
files85441272files
filet85540162filet
filial93013252filial
fill75540192fil_l
fille84327402fille
filler94623622filler
fillo84319782fillo
fills84632372fills
filly114424902filly
film94828172fil_m
filmer114112402filmer
filmi105914002filmi
films105617962films
filmy136114042filmy
filo76034282fil_o
filos86125382filos
fils75838692fil_s
filter94517632filter
filth115015822filth
filum105015432filum
final83922032final
finer85431562finer
fir66744892fi__r
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flab96628352f_lab
flag87427082f_lag
flair86114122f_lair
flak116026172f_lak
flam96333292f_lam
flan76134182f_lan
flap96128702f_lap
flare84823632f_lare
flat77147822f_lat
flaw106326642f_law
flax147325632f_lax
flay106332802f_lay
flier86023402flier
flir76422202f_lir
foliar93210972foliar
friar85414272friar
fubar1039922fubar
fulmar1137252fulmar
gular6314832gular
hila76228352hila_
izar136616012_izar
lar37967532__lar
liar47229682li_ar
lidar6312722lidar
lilac7311072lilac
malar76424442malar
miler75733062miler
molar75223092molar
mylar105311532mylar
oiler54628282oiler
pilaf103923482pilaf
pilau73618522pilau
pilaw103913742pilaw
pillar8314022pillar
polar75623452polar
simar74920812simar
sitar54820542sitar
sizar145214992sizar
solar55927342solar
talar56225382talar
tilak91011552tilak
tiler56131022tiler
tolar55524112tolar
velar85817632velar
vicar10513862vicar
viler86324162viler
volar86917412volar

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800991.53035163.4
3Display Results99990.0333000.0
 (SQL Overall)178691991.656107905.2
 
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.