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 “riflip” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
riflip113472(None) 
riflips1234161riflips
fillip11268952fillip
flip96324262__flip
rifle85518332rifl_e
rifled104115002rifled
rifler94014262rifler
rifles94217702rifles
rifling112815012rifling
aioli5318313aioli_
aiolis6316843aiolis
biali73419073biali_
bialis83617163bialis
biffin14369103biffin
bifid11910703bif_id
biflex1834953biflex
billie85019173billie
blip88322773__blip
cilia73016763ci_lia
clip86924003__clip
fillips12298133fillips
flap96128703__flap
flic96223733__flic
flips105117743__flips
flir76422203__flir
flit76539273__flit
flop96925453__flop
gillie74816943gillie
girlie73711463girlie
griffin1434513griffin
hili75626633hi_li_
ilia46026823_i_lia
inclip1036823inclip
kilim11711893ki_lim
killie104114893killie
lip514755803___lip
milia72719573mi_lia
mislie83219153mislie
mislit83019693mislit
oxlip1456883_oxlip
pili66130353pi_li_
pilis75825203pi_lis
raffia12287703raffia
ratlin64116523ratlin
realia6314593realia
redip87816963r_edip
refile95122373refile
refill94514053refill
refilm114311403refilm
refit84230063ref_it
refix155212483ref_ix
reflag1098083reflag
reflet94024233reflet
reflew12389453reflew
reflex16359513reflex
reflies104418533reflies
reflow12379653reflow
reflux16315413reflux
refly113914563refl_y
relic74623363r_elic
relit55340683r_elit
reship11310673reship
rial45938093rial__
rials55026673rial_s
rialto638603rialto
riblet84222443riblet
riblike1337333riblike
ricin74620213ri_cin
ridgil8316823ridgil
ridley10169543ridley
riel46432383riel__
riels55121333riel_s
rif65951563rif___
rife74632323rif__e
rifely123710033rifely
rifer84721983rif_er
rifest93114583rifest
riff104430103rif__f
riffed133811563riffed
riffing144011273riffing
riffle124210233riffle
riffled14338603riffled
riffler13328353riffler
riffles133911163riffles
riffling1556113riffling
riffs115114613rif_fs
riflers103512193riflers
riflery13345803riflery
riflings12227303riflings
rifs74929003rif__s
rift75642333rif__t
rifted104115313rifted
rifting113515003rifting
rifts85718643rif_ts
rigid7913893ri_gid
rile45650533ri_l_e
riled65833253ri_led
riles55343643ri_les
riley84420583ri_ley
riling74227973ri_ling
rill45140903ri_l_l
rille55728733ri_lle
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rilling84023623rilling
rills55032713ri_lls
rip56851303r___ip
riprap1055513riprap
rishi8311253rishi_
rishis9312453rishis
sialic8313633sialic
sialid7314943sialid
simlin8311733simlin
slip67031733__slip
tiffin12327933tiffin
trifid1039063trif_id
trifle94012883trifl_e
trifled113711963trifled
trifler103912153trifler
trifles103814823trifles
trifling122411503trifling
tulip71111693_tulip
unclip1046993unclip
villi86517853villi_
violin9311983violin
willie94116453willie

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161275.83019333.8
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.26628517.6
 
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.