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

336 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
builders114674(None) 
builder1037571builder_
guilders1035511guilders
bailers94221352bail_ers
bewilders1543812bewilders
bidders114012302b_idders
biders94822802b_i_ders
bilkers134711862b_ilkers
billers94720822b_illers
binders103920742b_inders
birders103913262b_irders
blinders113911142blinders
boilers93417062boil_ers
boulders113010022boulders
bowlders14306492bowlders
bridlers11359182bridlers
budders113812102bu_dders
buglers105115322bugl_ers
builded1136472builde_d
builds9378492build__s
buildups1342032buildups
bulgers105215142bu_lgers
bundlers11399182bundlers
burlers94120272burl_ers
butlers94518052butl_ers
gilders94212462_gilders
guiders94111102gui_ders
guilder945912guilder_
quilters17228432quilters
upbuilders1551352upbuilders
wilders113513502_wilders
abiders104011083abi_ders
aiders74524633_ai_ders
alders74218423__alders
aulder7511453au_lder_
bailees93914383bail_ees
bailer85425253bail_er_
baileys12388933bail_eys
bailies94120203bailie_s
bailors93212403bail_ors
baiters94619303bai_ters
balder95318863b_alder_
balers85626933b_al_ers
balkers134915723b_alkers
ballers94421013b_allers
banders104324563b_anders
bawlers124412733bawl_ers
beaders104120183b_eaders
bedders113513383b_edders
beguilers1252873beguil_ers
beholders1544933beholders
beliers94617383b_eliers
belters93819413b_elters
benders104021063b_enders
bewilder1434133bewilder_
bibbers103911353b_ibbers
bickers154316553b_ickers
bidder104114863b_idder_
bider85728373b_i_der_
bides85536773b_i_de_s
bidets95215533b_i_dets
biers76225223b_i__ers
bikers124517553b_i_kers
bilanders1235963b_ilanders
bilayers13296913b_ilayers
biles75542143b_il_e_s
bilges94915633b_ilge_s
bilker124913443b_ilker_
biller84923483b_iller_
billets94516153b_illets
binder94422873b_inder_
bindery13459823b_indery
biners85023633b_i_ners
bingers104519983b_ingers
birder94915493b_irder_
birlers93813003b_irlers
bisters93922603b_isters
biters83925233b_i_ters
bitters94920353b_itters
bladders12397803bladders
bladers104214683b_laders
bleeders11448453bleeders
blenders115210993blenders
blinder103912983blinder_
blinkers14388503blinkers
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
blunders113911333blunders
boarders11408623boarders
boiler84319273boil_er_
boilovers1444103boilovers
bolder94820933b_older_
bolides10515073bolide_s
bolters94017803b_olters
bonders104120663b_onders
boodlers113710743boodlers
borders104317533b_orders
boulder103411343boulder_
bouldery14295013bouldery
bounders114314103bounders
bowlder13407473bowlder_
bowlers123715783bowl_ers
braiders114110573braiders
braillers1135553braillers
branders114313093branders
breeders11368893breeders
bribers114111493bri_bers
brides94423513bri_de_s
bridler103811073bridler_
bridles104114473bridle_s
briefers1335143briefers
briers85319733bri__ers
brimmers14287073brimmers
briners94315633bri_ners
bringers112811073bringers
broiders114211183broiders
broilers103210093broil_ers
brooders112610233brooders
bruisers10307953brui_sers
bruiters10329133brui_ters
bubblers11448943bubblers
buckers153517453bu_ckers
bucklers16349503bucklers
budder104314813bu_dder_
buddles113913073buddle_s
budgers114314923bu_dgers
budless1038873budl_ess
buffers153310793bu_ffers
buggers114315663bu_ggers
bugler94717723bugl_er_
bugles94822443bugl_e_s
build84413353build___
building1237503building
buildings1334253buildings
buildup1242333build_up
bulbels11398013bu_lbels
bulger94917353bu_lger_
bulges95919323bu_lge_s
bulgurs10397113bu_lgurs
bulldogs1274243bulldogs
bulldozers2252033bulldozers
bullets93516393bu_llets
bullier94116433bullier_
bullies94121893bullie_s
bullpens1254083bullpens
bumblers143710733bumblers
bummers133712443bu_mmers
bumpers133912053bu_mpers
bundler104011723bundler_
bundles103515773bundle_s
bunglers11398483bunglers
bunkers133715953bu_nkers
bunters94717113bu_nters
burblers12399263burblers
burdens1039713bu_rdens
burgers103918573bu_rgers
burghers1435633burghers
buriers94017193bu_riers
burkers133716623bu_rkers
burladero1242133burladero
burladeros1351393burladeros
burler84723833burl_er_
burleys12479673burl_eys
burlier93514413burlier_
burners94115673bu_rners
burrers93814493bu_rrers
bursters1038983bursters
bushers124018803bu_shers
buskers133414083bu_skers
busters94724123bu_sters
bustiers103810043bustiers
bustlers104210613bustlers
butchers153710183butchers
butler84220033butl_er_
butlery12369423butl_ery
butles84423913butl_e_s
butters94521713bu_tters
buyers114511003bu__yers
buzzers17347173bu_zzers
byliners1334753byliners
ceilers93912533ceil_ers
chiders135312943chi_ders
childes134211273childe_s
chillers133710913chillers
ciders94620083_ci_ders
cinders104617753_cinders
coilers93619903coil_ers
cuddlers12388383cuddlers
cullers93418843cu_llers
culvers12329823cu_lvers
curdlers11368493curdlers
curlers94218063curl_ers
cutlers94216993cutl_ers
drillers9429713drillers
duelers83412053duel_ers
duellers9268223duellers
duikers12369383dui_kers
eiders74321363_ei_ders
elders74817303__elders
evildoers1341773evildoers
exilers14419733exil_ers
fielders12156773fielders
filers94623723_fil_ers
fillers104320203_fillers
filmers124211293_filmers
filters103816543_filters
finders113717873_finders
flinders12439263flinders
folders113514393_folders
frillers11349863frillers
fuelers103912393fuel_ers
fuellers11277983fuellers
fullers103817373fu_llers
funders113813933fu_nders
furlers104214223furl_ers
fusileers1242703fusileers
fusiliers1243703fusiliers
gelders93812573_gelders
gilder84415533_gilder_
gillers84216893_gillers
girders9379943_girders
gliders94811843gli_ders
gridders11286293gridders
grillers93810803grillers
grinders103410423grinders
guarders1035873guarders
guider84313523gui_der_
guides84118283gui_de_s
guilds8388353guild__s
guiles73919283guil_e_s
guldens9356573gu_ldens
gulpers10299003gu_lpers
hailers104017263hail_ers
hiders104919653_hi_ders
hillers103718723_hillers
hinders113718503_hinders
holders113715903_holders
huddlers13337633huddlers
hullers103616263hu_llers
hurdlers12337493hurdlers
hurlers103714323hurl_ers
idlers74012813__idlers
jailers144114043jail_ers
jilters144211953_jilters
joinders16337203joinders
judders16347793ju_dders
juicers1636153jui_cers
kidders13399163_kidders
killers114215573_killers
kilters113813593_kilters
lullers73213353lu_llers
mailers94420333mail_ers
melders103213913_melders
mildens10339933_mildens
milder93818453_milder_
mildews13365883_mildews
milers84625163_mil_ers
milkers134411613_milkers
millers93621333_millers
milters93619083_milters
minders103720113_minders
moilers93615203moil_ers
molders103315553_molders
moulders11348333moulders
mudders113211103mu_dders
muddlers12428803muddlers
mullers93217303mu_llers
murders103311363mu_rders
nailers73215893nail_ers
oilers64721193_oil_ers
outliers82610673outliers
philters1398173philters
pilfers1238963_pilfers
pinders103720473_pinders
polders103617373_polders
puddlers12298683puddlers
pulers83820283pu_l_ers
pullers93618483pu_llers
pulpers114612283pu_lpers
pulsers94213153pu_lsers
quellers17237533quellers
quieters17248733quieters
quillets17256823quillets
quilter16279803quilter_
quippers2184803quippers
quitters17238523quitters
quivers19298753qui_vers
quizzers2542943quizzers
raiders84615143rai_ders
railers74420663rail_ers
ridders93612483_ridders
riders74123903_ri_ders
rudders93210643ru_dders
ruiners74213023rui_ners
rulers64317093ru_l_ers
sailers73822313sail_ers
scolders11288993scolders
shielders1334753shielders
sidlers83414223_sidlers
sillers73822093_sillers
silvers104714033_silvers
skidders1454813skidders
sliders83515223sli_ders
smilers94113843smil_ers
smolders11287193smolders
solders83517773_solders
spiders103914413spi_ders
spillers103311693spillers
suiters73618873sui_ters
sulkers113613343su_lkers
sunders84120053su_nders
sutlers73116973sutl_ers
swillers11299103swillers
tailers73720183tail_ers
tildes74513963_tilde_s
tilers63523493_til_ers
tillers73418733_tillers
tilters73315933_tilters
tinders84219173_tinders
toilers74116263toil_ers
trillers83613483trillers
tuilles72411923tuille_s
udders83911293_u_dders
ulcers839383_u_lcers
upbuilder1441573upbuilder_
veilers103911823veil_ers
voiders11279823voi_ders
wailers103916803wail_ers
welders113313413_welders
widders123512263_widders
wielders12196613wielders
wilder103616473_wilder_
willers103517903_willers
winders113721263_winders
yielders12164743yielders

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623367.09320606.5
3Display Results3363360.1232731.7
 (SQL Overall)1786913367.37224239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.