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

70 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
hemipters164568(None) 
hemipter1545581hemipter_
demisters1249202demisters
emitters10349642_emitters
heisters113413132he_isters
hemipteran1753292hemipteran
hemipterans1852862hemipterans
hemipterous1852642hemipterous
peripters1368122peripters
remitters11328402remitters
tempters12257292tem_pters
admitters1244553admitters
cementers1338313cementers
deciphers1744393deciphers
demister11310223demister_
dempsters1435273dempsters
depicters1435823depicters
embitters13334723_embitters
emitter93211083_emitter_
emoters94712873_em_oters
emptiers1275193_em_ptiers
hampers143616953ham_p_ers
hamsters13710423ham_sters
heapers123616673he_ap_ers
heaters104225223he__aters
hefters134312003he__fters
heifers1337933he_i_fers
heister103613623he_ister_
helicopters1853153helicopters
helpers123311853he_lp_ers
hemisphere2053513hemisphere
hemispheres2153363hemispheres
hemmers143310843hem__mers
hempier14319003hem_pier_
heritors11310903heri_tors
hesitaters1374853hesitaters
hinters103719583h__inters
hipsters13268793h__ipsters
hitters104717593h__itters
hoisters113513483h_oisters
humpers142713523hum_p_ers
keisters123212043ke_isters
lamisters1157123lamisters
leisters83312823le_isters
limiters10249333limi_ters
meisters103313843me_isters
milters93619093__milters
minters93822473__minters
misters93927513__misters
miters84328783__mi_ters
omitters10277653_omitters
peripter1278753peripter_
permitters1444623permitters
reciters102613113reci_ters
refilters1236103refilters
registers1038893registers
reinters82614773re_inters
remasters11310583remasters
reminders12308653reminders
remitter102810323remitter_
remittors11256283remittors
resisters9310453resisters
scripters13116683scripters
semesters1139123semesters
smiters93414363_smi_ters
sumpters1238023sum_pters
tempers113513013tem_p_ers
tempter11358213tem_pter_
unmiters1037073unmi_ters
vomiters1337203vomi_ters

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 Filter1786911486410.423422437.4
2DLD Change Limit148641707.75019179.5
3Display Results70700.0302333.3
 (SQL Overall)178691708.20321783.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.