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

236 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
flivver163304(None) 
flivvers1733111flivvers
fiver116024942f_i_ver
flicker163610622flicker
flier86023402fli__er
flinder11319872flinder
flinger113710512flinger
flipper14389142flipper
flirter10318672flirter
flitter103413902flitter
flyover1633512flyover
liever94611862_liever
liver85132962_li_ver
livier97514592_livier
livyer12426292_livyer
sliver94116592sli_ver
aiver85725163_ai_ver
aliener71011193aliener
aligner8108313aligner
aliner65621983ali_ner
alive85722513ali_ve_
allover1038583allover
believer13448423believer
blinder103912983blinder
blinker134110213blinker
blister94415313blister
blither124812173blither
blitzer18447663blitzer
claver113816973cl_aver
clavier1239173clavier
cleaver124110803cleaver
clever114611533cl_ever
clicker154111883clicker
climber13449133climber
clinger103812153clinger
clinker133811663clinker
clipper133710323clipper
clivers123411753cli_vers
clover114617123cl_over
deliver113312243deli_ver
diver94827803_di_ver
driver104714493dri_ver
elver85216243el__ver
fainer94717243fai_ner
fainter103611053fainter
fairer95212063fai_rer
feigner1135593feigner
fever115617953f__ever
fibber134811933f_ibber
fiber104921133f_i_ber
fifer115519973f_i_fer
filcher15377793filcher
filer85433003f_i_ler
filister1137403filister
filler94623623f_iller
filmer114112403f_ilmer
filmier1237503filmier
filter94517633f_ilter
finder104020233f_inder
finer85431563f_i_ner
finger104920333f_inger
firer811229253f_i_rer
firmer114712443f_irmer
fisher124917143f_isher
fitter94120033f_itter
five107629743f_i_ve_
fivers124420923f_i_vers
fives116027363f_i_ves
fixer154717833f_i_xer
fizzer17369383f_izzer
flagger12469353flagger
flaker134916173fl_aker
flakier143910203flakier
flamer114919123fl_amer
flamier123112143flamier
flanger113412623flanger
flanker143911293flanker
flapper14359203flapper
flasher133914063flasher
flatter103815963flatter
flavor1236663fl_avor
flavorer1454553flavorer
flavour1334633flavour
flawier13378733flawier
flaxier17337983flaxier
flayer124713563fl_ayer
fleecer12368033fleecer
fleer86020773fl__eer
fleeter103210363fleeter
flenser1036783flenser
flesher133610923flesher
flichter1664963flichter
flicked174610673flicked
flickers17338883flickers
flickery20365103flickery
flied96519433fli__ed
fliers94417193fli__ers
flies85630713fli__es
flimsier1344133flimsier
flincher16256583flincher
flinders12439263flinders
flingers123410193flingers
flinted114411893flinted
flintier1136393flintier
flipped15358513flipped
flippers15338003flippers
flir76422203fli___r
flirted11428673flirted
flirters11337933flirters
flirtier1144893flirtier
flite85424963fli_te_
flited104616583fli_ted
flites95122443fli_tes
flitted114011643flitted
flitters114312173flitters
floater104413353floater
flogger12449463flogger
flooder11258463flooder
floorer10248073floorer
flopover1642863flopover
flopper14328473flopper
flosser10339693flosser
flouter104311343flouter
flower124815503fl_ower
flubber14287713flubber
fluffer12336503fluffer
flukier14397853flukier
flunker14389363flunker
flusher133012273flusher
fluster103913063fluster
fluter95316863fl_uter
flutier103011553flutier
flutter104012093flutter
flyer114916253fl__yer
flyovers1733673flyovers
flytier13356503flytier
forever1338953forever
frier85225843fri__er
friller104111743friller
frisker14389273frisker
fritter103912773fritter
frivoler1443933frivoler
frizer184011283fri_zer
frizzer18446893frizzer
giver94921203_gi_ver
glibber1235163glibber
glider84614263gli_der
glimmer12437713glimmer
glister84013343glister
glitter84211803glitter
glover104513533gl_over
griever1136033griever
jiver155119053_ji_ver
jivier16438613_jivier
klister113410643klister
laveer94110423_laveer
laver85031793_l_aver
leaver94321513_leaver
lever85125163_l_ever
levier94013873_levier
libber104414013_libber
liber74723623_li_ber
licker125222043_licker
lieder74912323_lieder
liefer9529573_liefer
lier45942463_li__er
lieve86315473_lieve_
lifer85822153_li_fer
lifter93814813_lifter
liger65024473_li_ger
liker95627063_li_ker
limber104316793_limber
limier83518723_limier
limmer104314793_limmer
limner84112873_limner
limper104117853_limper
liner55938923_li_ner
linger75226003_linger
linier64423793_linier
linker104321473_linker
linter64625343_linter
lipper104219633_lipper
lisper84114433_lisper
lister64527253_lister
liter54736343_li_ter
lither94520953_lither
litter64324853_litter
live76540993_li_ve_
lived95523723_li_ved
liven85021733_li_ven
livener10278943_livener
livers94927823_li_vers
livery124910903_li_very
lives86133193_li_ves
liviers104211073_liviers
livre85613253_livre_
livres94311863_livres
livyers13365903_livyers
louver94110393_louver
lover85526453_l_over
naiver94311353nai_ver
olive84817153oli_ve_
olives94313953oli_ves
plier75221283pli__er
plinker134010963plinker
plover115312613pl_over
privier122910453privier
quiver18278743qui_ver
reiver95318293rei_ver
reliever11448683reliever
reviver134411373reviver
riever94811653_riever
river85731693_ri_ver
shiver124517373shi_ver
silver93815813_silver
siver85728613_si_ver
skiver134612103ski_ver
slaver94419613sl_aver
slicer84117603sli_cer
slicker133314533slicker
slider73918363sli_der
slier54827243sli__er
slieve9359273slieve_
slieves10378963slieves
slimier93212013slimier
slimmer114211343slimmer
slinger83413833slinger
slipover1343833slipover
slipper113712983slipper
slither104112983slither
slitter73615873slitter
sliverer11237633sliverer
slivers104115253sli_vers
stiver93915733sti_ver
waiver124212713wai_ver
wiver115924513_wi_ver

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272366.71619956.4
3Display Results2362360.0802950.0
 (SQL Overall)1786912367.20224811.3
 
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.