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

161 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
nullahs1031699(None) 
mullahs12388731mullahs
nullah9388141nullah_
cullays12347702cullays
fellahs13428392fellahs
fullams1236552fullams
hallahs133912462hallahs
mollahs12328282mollahs
mullah113710732mullah_
mullas84215932mulla_s
nulls55019982null__s
wallahs13409472wallahs
zillahs1935382zillahs
allays94313743_allays
almahs118611613_almahs
ballads104212913ballads
blahs105616513__blahs
bulla74620563bulla__
bullace113410673bullace
bullaces12299433bullaces
bullae83416163bulla_e
bullate93415073bullate
bullbats1255893bullbats
bullets93516393bullets
bullies94121893bullies
bullish12511193bullish
bullous9311663bullous
bulls75629573bull__s
burlaps1156253burlaps
callans94518473callans
callas84526753calla_s
cellars93713693cellars
chalahs15289883chalahs
challahs16377563challahs
collars93816573collars
cullay113910173culla_y
cullers93418853cullers
cullets94015613cullets
cullies94419963cullies
cullis84115993cull_is
culls75425813cull__s
cutlas8313103cutla_s
cutlass938013cutlass
dollars83311023dollars
dulias71212743dulia_s
dullard936603dullard
dullards1045493dullards
dullish1148743dullish
dulls64523743dull__s
fallals103310193fallals
fellah124910773fellah_
fellas95116963fella_s
fulhams1543983fulhams
fullam1138363fulla_m
fullers103817373fullers
fulls84623523full__s
fulmars1246423fulmars
galahs105512683_galahs
gulags837543gu_lags
gullets84013713gullets
gulleys11438523gulleys
gullies84717313gullies
gulls65222983gull__s
halalahs14367443halalahs
hallah124115403hallah_
halvahs16417533halvahs
hollas94616903holla_s
hulas84920883hu_la_s
hullers103616263hullers
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hull_os
hulls84923563hull__s
huppahs1743333huppahs
hurrahs13336773hurrahs
huzzahs2143083huzzahs
jubbahs2143623jubbahs
jubhahs2242353jubhahs
keblahs1634563keblahs
kiblahs1634153kiblahs
kulaks976113ku_laks
lallans74113533lallans
lullaby1243363lullaby
lullers73213353lullers
lulls54119653lull__s
mollah11319453mollah_
moolahs12347383moolahs
mulla74317113mulla__
mullahism1642523mullahism
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mulls75124153mull__s
nalas55528363n_ala_s
nellies73418723nellies
nilgais845203nilgais
nilgaus844003nilgaus
nills54926673nill__s
nubias8310093nubia_s
nuchals12216933nuchals
nucleus956573nucleus
null45125313null___
nulled74318273null_ed
nullify1334713nullify
nulling83818063nulling
nullity1037363nullity
numbats1137673numbats
nurls55519683nurl__s
nutlets74111253nutlets
nyalas936903nyala_s
ollas54218283_olla_s
outlaws10249603outlaws
outlays102610903outlays
pillars9313493pillars
pujahs18404943pu_jahs
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pullmans1253933pullmans
pulls74425053pull__s
pullups1134233pullups
pulsars9358913pulsars
punkahs16284783punkahs
purdahs13285483purdahs
quillais1745003quillais
rupiahs1253333rupiahs
selahs9313213_selahs
subahs114512383su_bahs
succahs1435323succahs
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sullage859913sullage
sullages939973sullages
sullies74122233sullies
sulphas1236243sulphas
sultans72411833sultans
sunnahs10326593sunnahs
surahs94515543su_rahs
tulles63218893tull_es
tussahs10335113tussahs
uhlans937573_uhlans
ulans54921303_u_lans
ullage739043_ullage
ullages838953_ullages
ulnas55716533_ulna_s
ulvas84511503_ulva_s
unlash938793_unlash
unlays93810493_unlays
unleads8228623unleads
unleash1034963unleash
unloads8278523unloads
villas96117263villa_s
vulgars11306533vulgars
vulvas12388843vulva_s
wallah124011993wallah_
wallas95719393walla_s
yulans958673yu_lans
zillah1836563zillah_

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.440406115.9
2DLD Change Limit1340271616.95319276.1
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.45623966.1
 
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.