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

106 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
hejiras174423(None) 
hegiras1136101hegiras
hejira1644801hejira_
hegira1036522hegira_
heirs85618562he_ir_s
hetairas1145602hetairas
hijras1635772hij_ras
ajivas1655133_ajivas
begirds1134883begirds
bemires113212833bemires
ceibas1038503ce_ibas
cerias83321983ceri_as
cesuras958693cesuras
deairs74013783deair_s
desires81316133desires
emirs76116163_emir_s
eras45441503_e__ras
ericas8315463_ericas
extras13310223_extras
eyras84715923_e_yras
fajitas1734253fajitas
fedoras1137923fedoras
feijoas1742323feijoas
ferias95020393feri_as
hairs86225173h_air_s
hajis156716283haji__s
hears86737373he_ar_s
hearts96218943he_arts
heders104119763heder_s
hegaris11310433hegaris
heils85222193he_i_ls
heir77523803he_ir__
heired103813043he_ired
heiress1036813he_iress
heists96814633he_ists
heliac111010893heli_ac
heliast10312073heli_ast
helical12311153helical
helices12313723helices
helios94816633heli_os
helipad1344723helipad
helipads1443873helipads
heliums12188303heliums
helixes1739133helixes
hemins113417573hemi_ns
hemiolas1387063hemiolas
hennas94211803he_nnas
henries102718283henries
henrys12366103he_nrys
herbs105520503he__rbs
herds96424683he__rds
heres86245903he__res
heriots10312063heriots
herls85226433he__rls
herms105626433he__rms
hernias10310773hernias
herns84825583he__rns
heros84930863he__ros
herries104025073herries
hers75844873he__r_s
hetaeras1146733hetaeras
hetaira1045903hetaira_
hetairai1143533hetairai
heteros10312683heteros
hewers123715273hewer_s
hexers165612753hexer_s
hijinks2132003hijinks
hijra1535643hij_ra_
hijrah1934283hij_rah
hijrahs2043443hij_rahs
hires86134343h__ires
horas86333103h__oras
hydras13239313h_ydras
kefirs13396653kefir_s
keirs95313673ke_ir_s
kerrias11289513kerrias
lempiras1243853lempiras
liras56021983__liras
mbiras1077153_mbiras
medias93620783medi_as
medinas103411463medinas
nairas6312783_nairas
redias74523603redi_as
refires104820313refires
reginas85614063reginas
rehires105016113rehires
rejigs14368093reji_gs
remoras9314073remoras
retinas74819353retinas
retires74726213retires
rewires104717113rewires
semiraw1246053semiraw
senoras72714953senoras
sepias83616103sepi_as
sheilas1059403she_ilas
tenias64720073teni_as
tephras1236283tephras
terras63516973te_rras
tetras63017623te_tras
theirs94610353the_ir_s
venires103012453venires
veritas103012753veritas
weirds10478053we_irds
weirs84316493we_ir_s
xenias133712973xeni_as
zebras1737853ze_bras

Search took 7 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 Limit1340271066.22021547.7
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.67026790.3
 
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.