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

276 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
gambiers1333707(None) 
gambier124711961gambier_
gambirs12359071gambi_rs
gamblers13369731gamblers
ambeers11428922_ambeers
ambers104519562_amb_ers
amblers115213562_amblers
cambers134017432camb_ers
gabbers124612832ga_bbers
gabbier12379632gabbier_
gabblers134110082gabblers
gabies93820722ga_bie_s
gambes116318312gamb_e_s
gambias125010722gambi_as
gambir11509752gambi_r_
gambits12399712gambi_ts
gambler123612682gambler_
gambles124016202gamble_s
gambrels1334212gambrels
gamers94420822gam__ers
gamier93617932gam_ier_
gammers123214562gam_mers
gammier123711192gammier_
garblers113810282garblers
lambers113817102lamb_ers
lambier113611632lambier_
lambies113015102lambie_s
ramblers124010372ramblers
abiders104011083_a_biders
ambeer104511593_ambeer_
amber94523203_amb_er_
ambery133811123_amb_ery
ambient11310083_ambient
ambients1246053_ambients
ambits103713403_ambi_ts
ambivert1545613_ambivert
ambiverts1642503_ambiverts
ambler104916443_ambler_
ambles105121853_amble_s
ambries111614533_ambrie_s
ameers84015573_am_eers
amies76837683_am_ie_s
amirs75924913_am_i_rs
amusers94610193_amusers
arbiters1038853_arbiters
babblers113510353babblers
babier103515563ba_bier_
babies106123643ba_bie_s
bambinos1443873bambinos
barbers114317503barb_ers
barbies114519593barbie_s
barriers104311883barriers
biers76225223___biers
bombers134512593bomb_ers
bumblers143710733bumblers
cabbies133115163cabbie_s
cabers105023903ca_b_ers
cablers114416713ca_blers
cahiers123510673ca_hiers
calibers1238523calibers
camber124418473camb_er_
cambisms1645793cambisms
cambists1437023cambists
cambiums1644923cambiums
cammies134016473cammie_s
campers134220283cam_pers
campier133313273campier_
carriers103614203carriers
cashiers13318883cashiers
catbriers1344143catbriers
chambers173410613chamb_ers
clambers144211283clamb_ers
combers134516613comb_ers
combiners15247943combiners
cumbers134515393cumb_ers
dabbers123813213da_bbers
dabblers13379363dabblers
dalliers93610613dalliers
damagers1237063damagers
dammers123214273dam_mers
damners104112113dam_ners
dampers123915693dam_pers
darbies104216983darbie_s
daubers104610423daub_ers
daubier1037093daubier_
embers104116173_emb_ers
fablers124812613fa_blers
fanciers13358083fanciers
farriers113610743farriers
fumblers15318713fumblers
gabber114916603ga_bber_
gabbiest1337273gabbiest
gabbiness1434403gabbiness
gabbler124013303gabbler_
gabbles124415413gabble_s
gabions102410053ga_bions
gables94222333ga_ble_s
gadders103611503ga_dders
gaffers14428713ga_ffers
gagers84021323ga__gers
gaggers103413663ga_ggers
gagsters10317073gagsters
gainers84214593ga_iners
gaiters83516533ga_iters
galabiehs1542443galabiehs
gallies84122713gallie_s
gambades1435863gambades
gambados1444143gambados
gambas115817513gamb__as
gambe106219213gamb_e__
gambia115912233gambi__a
gambit114714193gambi__t
gamble115417183gamble__
gambled134112163gamble_d
gamboges1435653gamboges
gambols1238593gamb_ols
gambrel1235453gambre_l
gambs105721123gamb___s
gameness112810693gameness
gamer84928943gam__er_
games86238553gam__e_s
gamesters1236733gamesters
gametes10312253gamete_s
gamiest102816223gam_iest
gamines103618463gam_ines
gaminess112911053gaminess
gamings114610913gam_ings
gamins94420043gam_i_ns
gammer1112318333gam_mer_
gammiest13339323gammiest
gammoners1444563gammoners
ganders93521703ga_nders
gangers94418603ga_ngers
gaolers83511563ga_olers
gapers94520463ga__pers
gappier12369843gappier_
garbler104012563garbler_
garbles104016923garble_s
garbless11388253garbless
garglers10418263garglers
garners83815983ga_rners
garters84218223ga_rters
gasaliers1044513gasaliers
gaseliers1044923gaseliers
gasifiers1344523gasifiers
gasoliers1044203gasoliers
gaspers105014133ga_spers
gassers84714633ga_ssers
gassier83812573gassier_
gasters85624283ga_sters
gaters74728633ga__ters
gathers114315063ga_thers
gaudier938453gaudier_
gaudies9311973gaudie_s
gauffers1563833gauffers
gaugers94211703ga_ugers
gauzier1735633gauzier_
gawkers15347453ga_wkers
gawkier15326523gawkier_
gawkies15429123gawkie_s
gawpers13448313ga_wpers
gazers164516293ga__zers
gemmier12337383gemmier_
gibbers124710983g_ibbers
gibers95114663g_ib_ers
gimmies123010103gimmie_s
gimpier12247933gimpier_
glaciers11277893glaciers
glaziers18406563glaziers
gobblers13308343gobblers
gobies95418053g_obie_s
gombeens1342703gombeens
gomers94116883gom__ers
goobers10219623goob_ers
grabbers13337883grabbers
grabbier13316653grabbier_
grabblers14345513grabblers
graziers18387123graziers
grubbers13316193grubbers
grumblers14245023grumblers
gummers123712193gum_mers
gummier12349473gummier_
hammers144216053ham_mers
hammier143510653hammier_
hampers143616943ham_pers
hamsters13710423hamsters
harriers113712433harriers
hauliers1176713hauliers
humblers15379803humblers
iambics13425633iambi_cs
imbibers1433483_imbibers
jabbers183610583ja_bbers
jambes175914053jamb_e_s
jammers183710703jam_mers
jammier18408023jammier_
jammies183611293jammie_s
jumblers19358323jumblers
lamber104418493lamb_er_
lambert113617113lamb_ert
lamberts12348783lamb_erts
lambie103213663lambie__
lambiest122410183lambiest
lampers113817333lam_pers
lamsters1099753lamsters
lanciers10308543lanciers
limbers113614733limb_ers
limbier11349103limbier_
lumbers113815913lumb_ers
mamboes135011823mamboe_s
mamies104626243mam_ie_s
mammers104615693mam_mers
mammies104314763mammie_s
mamzers20409163mam_zers
marblers12319233marblers
marriers103312473marriers
members13258603memb_ers
mumblers14328763mumblers
nabbers113710463na_bbers
namers84517333nam__ers
numbers113711243numb_ers
ombers104214393_omb_ers
pampers133615933pam_pers
paniers94717333pa_niers
panniers10488853panniers
parriers103612903parriers
partiers103514243partiers
rabbies113416053rabbie_s
rabbiters1343733rabbiters
rabblers123810853rabblers
rabies85226013ra_bie_s
ralliers84010833ralliers
rambler113313263rambler_
rambles113118313ramble_s
ramies84630463ram_ie_s
rammers113715043ram_mers
rammier112811023rammier_
rapiers95012873ra_piers
ribiers9319753_ribiers
rumblers123610743rumblers
sabers85224733sa_b_ers
sabirs85414623sa_bi_rs
salliers83613333salliers
saltiers83411953saltiers
sambars115113843samb_ars
sambhars1544833sambhars
sambhurs1543183sambhurs
samburs11369343samb_urs
samiels939763sam_iels
samplers12299403samplers
sauciers1076733sauciers
tabbies112913503tabbie_s
tabers84621573ta_b_ers
talliers83711363talliers
tambours1255863tambours
tamburs11288603tamb_urs
tamers84224033tam__ers
tammies113814683tammie_s
tampers113516743tam_pers
tarriers83411713tarriers
tarsiers8298533tarsiers
timbers113111833timb_ers
tumblers123110623tumblers
umbers104215203_umb_ers
vampers143111623vam_pers
vampier14308233vampier_
vampires15226033vampires
variers103712663va_riers
wabblers15398993wabblers
wambles143714023wamble_s
wamblier15275733wamblier_
warblers13319103warblers
wombier1436533wombier_
yabbers14389353ya_bbers
yabbies14279643yabbie_s
yammers143410323yam_mers
zombies2037983zombie_s

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 Limit1461622766.76321612.0
3Display Results2762760.1102509.1
 (SQL Overall)1786912767.02925422.0
 
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.