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

143 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
hejira164480(None) 
hegira1036521hegira
hejiras1744231hejiras
hegiras1136102hegiras
heir77523802he_ir_
heirs85618562he_irs
hetaira1045902hetaira
hijra1535642hij_ra
aecia73819283aeci_a
ajiva1586803_ajiva
begird1036823begird
begirt9412683begirt
bemire103312803bemire
ceiba938703ce_iba
centra84113883centra
ceria75125353ceri_a
cesura838763cesura
deair65817193deair_
deairs74013783deairs
deliria868303deliria
desire7415303desire
emir65918703_emir_
emirs76116163_emirs
era35741503_e__ra
erica7316543_erica
extra1239003_extra
eyra76217553_e_yra
fajita1635923fajita
fedora1038593fedora
feijoa1642223feijoa
femora1149583femora
feria85922713feri_a
genera71211713genera
haika125313793h_aika
hair76330143h_air_
hairs86225173h_airs
hairy115316833h_airy
haji148520193haji__
hajis156716283haji_s
haniwa1236743haniwa
hear76143883he_ar_
heard95222753he_ard
hears86737373he_ars
heart85440743he_art
heder95623643heder_
heders104119763heders
hegari1039523hegari
heigh124812543he_igh
heil76328933he_i_l
heils85222193he_ils
heired103813043he_ired
heist87030913he_ist
heliac111010893heliac
helical12311153helical
helio85321193heli_o
helios94816633helios
helipad1344723helipad
helium112311253helium
helix154413013heli_x
hemic125718623hemi_c
hemin103620933hemi_n
hemins113417573hemins
hemiola12107003hemiola
henna84414043he_nna
henry114014473he_nry
her66547813he__r_
herb94730963he__rb
herd84933063he__rd
here76447103he__re
heriot9422343heriot
herl75834553he__rl
herm95636153he__rm
herma105318883he_rma
hern76134893he__rn
hernia9312293hernia
hero74635783he__ro
herry114922473he_rry
hers75844873he__rs
hetaera1036493hetaera
hetairai1143533hetairai
hetairas1145603hetairas
hetero9312633hetero
hewer115719933hewer_
hewers123715273hewers
hewing134514243hewing
hexer155116683hexer_
hexers165612753hexers
hexing174210513hexing
hijrah1934283hij_rah
hijras1635773hij_ras
hila76228353h__ila
hire75538963h__ire
hora76136563h__ora
hydra12249223h_ydra
hydria13227903hydria
jejuna1243243jejuna
jura116024893__jura
kefir12457913kefir_
kefirs13396653kefirs
keir86217873ke_ir_
keirs95313673ke_irs
kerria10339913kerria
lempira1144193lempira
lexica1536103lexica
lira46928683__lira
mbira977973_mbira
media84721713medi_a
medina94114093medina
megara9310093megara
moira71012023_moira
naira5314743_naira
redia65524483redi_a
refire95419473refire
regina75317143regina
rehire95415863rehire
rejig133810123reji_g
rejigs14368093rejigs
remora8414593remora
retia55326113reti_a
retina65023383retina
retire64927013retire
rewire95421413rewire
semina8915573semina
semiraw1246053semiraw
senora63216163senora
sepia75318673sepi_a
sera46141393se__ra
sheila969843she_ila
telia55821143teli_a
tenia55324483teni_a
tephra1136483tephra
terra54419663te_rra
tetra53417953te_tra
their85512153the_ir_
theirs94610353the_irs
venire93513693venire
vera76828843ve__ra
vesica11157913vesica
weir76019923we_ir_
weird95111283we_ird
weirs84316493we_irs
xenia124814773xeni_a
zebra1637883ze_bra

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161434.87323130.7
3Display Results1431430.0334333.3
 (SQL Overall)1786911435.28233830.2
 
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.