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

135 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
airbags103629(None) 
airbag956961airbag_
airboats1047282airboats
airbus848342airb_us
airings83913842airings
airways1336242airways
dirtbags1242702dirtbags
kitbags1443882kitbags
mailbags1343902mailbags
abas68642083a__ba_s
abbas95918643a_bba_s
acreage1037833acreage
acreages1138363acreages
acrobats1258343acrobats
aerials74017553aerials
aerobats1049843aerobats
agrias74315393agria_s
airboat9512133airboat
airbrush1342343airbrush
airburst1044233airburst
airbuses1067073airbuses
airdate8311323airdate
airdates939723airdates
airers64922313air_ers
airfare1047243airfare
airfares1146693airfares
airheads1246133airheads
airing74927503airing_
airless73712043airless
airmail946213airmail
airmails1045273airmails
airman82414223airma_n
airns55521033air__ns
airpark1344923airpark
airparks1443913airparks
airplays1344533airplays
airs46447423air___s
airths95414253air_ths
airts55626343air__ts
airward1148133airward
airwave1344433airwave
airwaves1444723airwaves
airway1237693airwa_y
albas75925393a_lba_s
ambage11510603a_mbage
ambages1269623a_mbages
amebas10311453ameba_s
anabas8314083anaba_s
aortas65417783aorta_s
araks94820883a_r_aks
arbors84717883a_rbors
arbs66834733a_rb__s
areas55935773a_rea_s
argals75517713a_rgals
arhats9312973a_rhats
arias55438023a_ria_s
arras55626133a_rra_s
arrays95311683a_rrays
arrears738843arrears
arrobas969213arroba_s
atabals938413atabals
auras55932553aur_a_s
bags76645503___bags
brags85625103_br_ags
corbans11313173corbans
crags85622573_cr_ags
darbars10510093darbars
debags104211063_debags
dirams94413703dir_ams
dirhams13376313dirhams
dirtbag1143023dirtbag_
disbars10310323disbars
dorbugs1132983dorbugs
drags75521113_dr_ags
durbars1077973durbars
fairings12388193fairings
fairways1743873fairways
ferbams1435743ferbams
firebugs14113823firebugs
firings114112333firings
firmans12238523firmans
frags96322163_fr_ags
garbage1138053garbage
garbages1238183garbages
garbagy1444243garbagy
gasbags1135473gasbags
gimbals12257823gimbals
hairball1344633hairball
hairballs1443843hairballs
hairband1444573hairband
hairbands1544063hairbands
haircaps15144363haircaps
handbags15116363handbags
herbage1337003herbage
herbages1437093herbages
herbals122710603herbals
isbas71010403_isba_s
kitbag1334973kitbag_
libras83711703libra_s
limbas105313203limba_s
liras56021983lir_a_s
mailbag1243923mailbag_
mimbars1397383mimbars
mirage92313653mir_age
mirages102213533mir_ages
mirzas1738183mirza_s
nairas6312783nair_a_s
pairings11398313pairings
pibals103813083pi_bals
ragbags1135113ragbags
rags55448373__r_ags
ratbags1035763ratbags
sandbags1296373sandbags
scrags95713803scr_ags
seabags1037483seabags
sirdars8228213sirdars
sirrahs10377303sirrahs
sirras63814863sirra_s
sprags95715823spr_ags
tagrags936123tagr_ags
timbals11239533timbals
tribals9610753tribals
turbans939563turbans
verbals121910743verbals
virago1046643vir_ago
viragos1146713vir_agos
virgas1048883virga_s
wigwags1543293wigwags
windbags1544523windbags
wirings113910113wirings
workbags1843013workbags
yerbas11119293yerba_s
zaribas1836043zariba_s
zigzags1742273zigzags
zirams17438643zir_ams

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.1561145455.1
2DLD Change Limit1340271356.79619721.5
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.99825534.6
 
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.