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

68 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
qabalah2128503(None) 
qabala17399191qabala_
qabalahs22253291qabalahs
qabalas18289501qabalas
cabala103516912cabala_
cabalas113516002cabalas
cabbalah1763792cabbalah
habdalah1742612habdalah
halalah13429382halalah
kabala124011552kabala_
kabalas133911062kabalas
kabbalah1962432kabbalah
abaca95118043_abaca_
abacas104414723_abacas
abaka114313823_abaka_
abakas123911743_abakas
abash106016513_aba_sh
abaya104413173_abaya_
abayas114011703_abayas
bacalao1146613bacalao
balas76937213__balas
blah98625063__b_lah
cabal95222153cabal__
cabals104020153cabal_s
cabana103913563cabana_
cabanas112413033cabanas
cabbala1367183cabbala_
cabbalahs1862723cabbalahs
cabbalas1467373cabbalas
chalah143511653_chalah
fabular12288693fabular
falbala1235873falbala_
falbalas1345473falbalas
galah95917623__galah
habdalahs1842113habdalahs
halakah17517953halakah
halala94715093halala_
halalahs14367443halalahs
halalas104214083halalas
halavah16447013halavah
hallah124115403ha_llah
havdalah1842143havdalah
hawala12368913hawala_
hawalas13348353hawalas
kabaka11348503kabaka_
kabakas12367403kabakas
kabaya15387123kabaya_
kabayas16316803kabayas
kabbala1584613kabbala_
kabbalahs2051903kabbalahs
kabbalas1674353kabbalas
kamala12339963kamala_
kamalas13339123kamalas
keblah1545313keb_lah
kiblah1535583kib_lah
labara83712893labara_
masala8311813masala_
masalas9312053masalas
pabular11259473pabular
sabal75422483sabal__
sabals84618863sabal_s
subalar9118073subalar
tabla73318363tab_la_
tablas83716163tab_las
tabular9279763tabular
tambala1138023tambala_
tambalas1237033tambalas
wallah124011993wa_llah

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.1401276364.3
2DLD Change Limit134027688.17316398.8
3Display Results68680.0461478.3
 (SQL Overall)178691688.35921377.1
 
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.