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 “gazabos” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
gazabos194445(None) 
gazabo1834831gazabo_
gazaboes2043871gazaboes
gazebos1933491gazebos
galagos938152galagos
gazars164811552gaza_rs
gazebo1833672gazebo_
gazeboes2043392gazeboes
gazoos163010222gaz_oos
jazzbos2442032jazzbos
lavabos1235452lavabos
abos67734413___abos
adobos9438453_adobos
alamos8415003_alamos
ambos95321253_a_mbos
anabas8314083_anabas
azans146516883_aza_ns
azygos1933333_azygos
bayamos1434663bayamos
bazaars18275883bazaars
bazars174613113baza_rs
bazoos173212623baz_oos
cacaos104616183caca_os
carabaos1238083carabaos
carbos105122263ca_rbos
casabas1139983casabas
catalos9414163catalos
gabbros12124653gabbros
gabs76740423g__ab_s
gadabout1245563gadabout
gadabouts1342853gadabouts
gagakus1342883gagakus
galabia1038333galabia
galabias1137733galabias
galago838913galago_
galahs105512683gala_hs
galas65731643gala__s
galaxes1538883galaxes
gamas85431363gama__s
gamays126310913gama_ys
gambados1444153gambados
gambas115817513ga_mbas
gambes116318313ga_mbes
gambol1138223ga_mbol
gambols1238593ga_mbols
gambs105721123ga_mb_s
garages9314113garages
garbs86321413ga_rb_s
gasbags1135473gasbags
gauchos1345903gauchos
gavages1237683gavages
gayals1039513gaya_ls
gazania1746123gazania
gazanias1845733gazanias
gazar154612983gaza__r
gazers164516303gaz_ers
gazes155425913gaz__es
gazoo153112873gaz__oo
gazpachos2651343gazpachos
gazumps2131873gazumps
gelatos83111523gelatos
gitanos837173gitanos
gizmos1844133giz_mos
gobos86219383g__obos
gombos114311093g_ombos
grabs85719693g_rab_s
grazable2036223grazable
guacos94410313g_uacos
guanacos1163813guanacos
guanos73811993g_uanos
gumbos114610873g_umbos
hazans183411653haza_ns
hazards2037463hazards
jazzbo2342713jazzbo_
kababs14409773kabab_s
kakapos1243673kakapos
kazoos19259113kaz_oos
lavabo1135273lavabo_
lavaboes1344433lavaboes
lazars153812393laza_rs
macacos1338083macacos
mambos125414493ma_mbos
marabou1147493marabou
marabous1249063marabous
mazards1937703mazards
nawabs1185063nawab_s
parados103816053parados
paramos113213513paramos
rabatos93010903rabatos
sambos104315193sa_mbos
tapalos938813tapalos
wasabis1255363wasabis
wazoos18288553waz_oos

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.436409841.7
2DLD Change Limit134027937.94016880.0
3Display Results93930.0303100.0
 (SQL Overall)178691938.40621257.6
 
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.