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

274 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
wallahs1340947(None) 
hallahs133912461hallahs
wallah124011991wallah_
wallas95719391walla_s
allays94313742_allays
almahs118611612_almahs
ballads104212912ballads
callans94518472callans
callas84526752calla_s
challahs16377562challahs
fallals103310192fallals
fellahs13428392fellahs
galahs105512682ga_lahs
halalahs14367442halalahs
hallah124115402hallah_
halvahs16417532halvahs
lallans74113542lallans
mollahs12328282mollahs
mullahs12388732mullahs
nullahs10316992nullahs
walla85321032walla__
wallaby1535072wallaby
wallets103914832wallets
wallies103320742wallies
wallops123410412wallops
wallows133613532wallows
walls85529382wall__s
waylays1634672waylays
zillahs1935382zillahs
aahs716428563_a__ahs
alans55636173_a_lans
alas46358123_a_la_s
albas75925393_alba_s
alephs1136533_alephs
alfas87219043_alfa_s
algas65624933_alga_s
alias55834603_alia_s
aliyahs13395323_aliyahs
allay85620393_alla_y
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
alls46740923_all__s
allyls9437273_allyls
almah106917253_almah_
almas76629773_alma_s
almehs11619493_almehs
alohas9411703_alohas
alphas1139513_alphas
altars64518153_altars
always12409133_always
amahs107819063_a_mahs
anlas55626933_anla_s
atlas55821583_atla_s
ayahs116813523_a_yahs
balas76937213ba_la_s
ballad94315323balla_d
ballade104012563ballade
ballades114211643ballades
ballast9313993ballast
ballasts1037933ballasts
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballons93916963ballons
ballots94116033ballots
balls76236413ball__s
balsams11579013balsams
balsas86417523balsa_s
blahs105616513__blahs
calash11312433ca_lash
calcars11312653calcars
caliphs1436753caliphs
calla74827073calla__
callan83619603calla_n
callant94121223callant
callants104112143callants
callees94117783callees
callers94221963callers
callets93821703callets
callous93516603callous
calls75634733call__s
callus85317073call_us
calpacs133110343calpacs
casbahs1436463casbahs
cellars93713693cellars
chalahs15289883chalahs
challah15458323challah_
challas124414123challa_s
collars93816573collars
cullays12347703cullays
daledhs1232783daledhs
daleths1135323daleths
dalles74222063dall_es
dallies84023193dallies
dollars83311023dollars
earlaps936393earlaps
fallacy1536433fallacy
fallal93612693falla_l
fallers103917993fallers
fallows133713973fallows
falls85727653fall__s
fellah124910773fellah_
fellas95116963fella_s
fullams1236553fullams
galah95917643ga_lah_
galas65731643ga_la_s
galeas74618513galea_s
gallant83517113gallant
gallants93310373gallants
gallate83417133gallate
gallates92815533gallates
galleass935053galleass
gallets83517403gallets
galleys11369713galleys
galliass935423galliass
gallies84122713gallies
gallons83015953gallons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gall__s
gallus74313203gall_us
galyacs1335273galyacs
galyaks1534623galyaks
ganjahs18104003ganjahs
halakahs18426633halakahs
halalah13429393halalah_
halalas104214083halalas
halals95018313ha_lals
halavahs17415793halavahs
hallal94415563halla_l
hallels103310133hallels
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hall_os
hallows134417393hallows
halls85633783hall__s
hallways1745423hallways
halmas117017893halma_s
halvah15499833halvah_
halvas124714173halva_s
hamzahs24134373hamzahs
hollas94616903holla_s
jalaps15299183ja_laps
jarrahs1735453jarrahs
kalams12310603ka_lams
kalians11310183kalians
kaliphs1634293kaliphs
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943kalpa_s
kasbahs1634363kasbahs
keblahs1634563keblahs
kiblahs1634153kiblahs
lallan63414183lalla_n
lalland83810193lalland
lallands9338583lallands
lalls55324133lall__s
malars85020683ma_lars
mallard10310273mallard
mallards1138323mallards
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallows123714323mallows
malls76233433mall__s
malthas1237913malthas
matsahs1236563matsahs
matzahs2134483matzahs
mollah11319453mollah_
moolahs12347383moolahs
mullah113710733mullah_
mullas84215933mulla_s
nalas55528363na_la_s
nullah9388143nullah_
ollas54218283_olla_s
paellas9411413paella_s
palais8420423pa_lais
pallets93919303pallets
pallors9314363pallors
palls74332563pall__s
pardahs13289673pardahs
pariahs123812343pariahs
parlays123910453parlays
pillars9313493pillars
qabalahs22253293qabalahs
raglans82410133raglans
rajahs16497663ra_jahs
rallies73823343rallies
rallyes10348553rallyes
ralphs1135373ra_lphs
rayahs12579193ra_yahs
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
sallets73719653sallets
sallies73227813sallies
sallows103915553sallows
salpas85116923salpa_s
salsas65316133salsa_s
selahs9313213_selahs
swallows14295893swallows
tablas83716163tabla_s
talars66021683ta_lars
talas55935893ta_la_s
tallage82712073tallage
tallages92312003tallages
tallies73624603tallies
tallis63319963tall_is
tallish103313583tallish
talliths11377433talliths
tallits73215993tallits
tallols73311363tallols
tallows103313743tallows
talls55133433tall__s
tallyho1343043tallyho
tallyhos1443333tallyhos
vallate103016563vallate
valleys13407483valleys
villas96117263villa_s
wadmals1335513wadmals
wailers103916803wailers
wails86631483wail__s
walers94824463wa_lers
wales86142833wa_l_es
walies95324523wa_lies
walkers143411473walkers
walks126218503wa_l_ks
walkups1633013walkups
walkways2143213walkways
wall76236103wall___
wallabies1445733wallabies
wallaroo1144623wallaroo
wallaroos1244123wallaroos
walled104021293wall_ed
wallet93327093wall_et
walleye1336243walleye
walleyes1435603walleyes
wallie93216803wall_ie
walling113520973walling
wallop113310293wall_op
wallow123913513wall_ow
wally114625093wall__y
walnuts1033843walnuts
walrus956433wa_lrus
waltzes1935953waltzes
wangans1149503wangans
warless104015103warless
warmths1583783warmths
warpaths1643973warpaths
warsaws1335763warsaws
wataps11248683wa_taps
wauls86120553waul__s
wawls115416473wawl__s
waylaid1445093waylaid
waylay1535453wayla_y
wayless13308243wayless
wealths13365813wealths
wellies103719073wellies
wells85426193well__s
whidahs1743333whidahs
whydahs2041883whydahs
willers103517913willers
willets104414323willets
willies103920153willies
willows13299753willows
wills84528963will__s
zillah1836563zillah_

Search took 9 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.466383457.1
2DLD Change Limit1340272747.65617506.1
3Display Results2742740.1102490.9
 (SQL Overall)1786912748.23221706.9
 
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.