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

89 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
sahiwal134444(None) 
sahiwals1443641sahiwals
achiral12109183achiral
animal85016253_animal
apical10913903_apical
avowal1246323_avowal
axial124515193_axi_al
basinal9310033basinal
capital112311523capital
carinal94318243carinal
chiral114614413_chiral
chital114313883_chital
datival1135583datival
eschewal1643133eschewal
ethical1238443ethical
facial113615633faci_al
gavial10310083gavi_al
haniwa1236743haniwa_
ischial1246423ischi_al
labial84714343labi_al
laical8312323la_ical
laminal94113633laminal
lanital7310913lanital
magical1239783magical
marital92314183marital
matinal9312603matinal
maximal18347093maximal
nadiral836343nadiral
narial6317953nari_al
narwal938943na_rwal
nasial6413283nasi_al
paginal10269493paginal
phial10313203_phi_al
rachial122012173rachi_al
racial83419243raci_al
radial74020393radi_al
radical103312793radical
rhinal9510193_rhinal
sabal75422483sa__bal
sacral83414413sa_cral
sagittal943283sagittal
sahib10314763sahi__b
sahibs1137083sahi_bs
saiga64717933sa_iga_
saigas74114293sa_igas
sail45447163sa_i__l
salal55425703sa__lal
salina64221123salina_
salinas73116093salinas
saliva93110743saliva_
salivas10309603salivas
sambal105215183sa_mbal
samiel8313333sami_el
sandal73317283sa_ndal
schwa13426843sch_wa_
schwas14396983sch_was
scribal1137963scribal
seminal91213413seminal
serial64625863seri_al
shaitan1036893shaitan
shawl116217573s_haw_l
sheal84927703s_h_eal
shibah14387473s_hibah
shiel811023773s_hi_el
shikar1336803s_hikar
shill85325333s_hi_ll
shipway1844213s_hipway
shiva115915003s_hiva_
shivah15488543s_hivah
shivas124512413s_hivas
shoal83920273s_h_oal
shwa106014963s_h_wa_
shwas116415103s_h_was
sial45938833s__i_al
sisal54217733s__isal
social8813333soci_al
somital939403somital
spacial1138763spaci_al
spatial9310323spati_al
spheral1238423spheral
spinal84915313s_pinal
spiral83715343s_piral
spital83813873s_pital
staminal1046983staminal
statical1039423statical
stoical9310283stoical
taxiway2043463taxiway
vaginal11288403vaginal
vatical1239983vatical

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.420425454.8
2DLD Change Limit134027896.98619185.1
3Display Results89890.0302966.7
 (SQL Overall)178691897.43624030.5
 
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.