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

99 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
impairer124486(None) 
impaired1335141impaired
impairers1343711impairers
impacter14296572impacter
impair1036002impai__r
impairs1135822impair_s
impaler11298392impa_ler
imparter12357542imparter
implorer12125102implorer
impurer1136482imp_urer
repairer1036782repairer
airer54927893___airer
aspirer967903asp_irer
comparer143611363compa_rer
despairer1243693despairer
dimplier1336673dimpli_er
empaler11288353empa_ler
empire1039323emp_ire_
empires1139853emp_ires
emptier1187603empti_er
expirer1635993exp_irer
fairer95212063__fairer
gimpier12247943gimp_i_er
imager9108123im_a_ger
imaginer1144303imaginer
imaret81121233im_a_ret
imbalmer1443193imbalmer
imbiber1333593im_biber
impacted15286353impacted
impacters15305483impacters
impactor14265013impactor
impaint11511223impai_nt
impainted1454773impainted
impaints1236243impaints
impairing1445473impairing
impairment1644683impairment
impale102811663impa_le_
impaled12288513impa_led
impalers12226973impalers
impales113311763impa_les
impanel1137093impa_nel
imparity1546783imparity
impark14287073impa_r_k
imparked17264863imparked
imparks15276663impa_rks
impart102715143impa_r_t
imparted13248063imparted
imparters13276573imparters
imparts11298533impa_rts
impasse11246463impasse_
impasses12257523impasses
impaste11258003impaste_
impasted13297553impasted
impastes12238193impastes
impawned1643443impawned
impeacher1843093impeacher
impeder12438533imp_eder
impeller1236083impeller
impinger13315423impinger
implanter1385363implanter
implied1238623impli_ed
implies11312123impli_es
implore11176703implore_
implored13135373implored
implorers13124413implorers
implores12127043implores
importer12308913importer
imposer113310103imp_oser
imposter12288163imposter
impower14247123imp_ower
imprinter1385243imprinter
improper1444533improper
improver1545243improver
impugner13444233impugner
impure1038383imp_ure_
imputer1136533imp_uter
inquirer17235173inquirer
inspirer1045183inspirer
limpsier1234433limpsi_er
mailer84724183_m_ailer
maimer104514593_m_aimer
marrer83716673_m_arrer
paired95017523__paired
parer75839903__pa_rer
pimplier1445413pimpli_er
repaired1148953repaired
repairers1135283repairers
simperer1237173simp_erer
smearer94110403smea_rer
smearier1036953smearier
sparer84524963_spa_rer
umpire1047893ump_ire_
umpired1235783ump_ired
umpires1137813ump_ires
unfairer11184283unfairer
unhairer11174993unhairer
unimpaired1542053unimpaired
unpaired11208943unpaired
wimpier14248053wimp_i_er

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 Filter1786911461620.420425454.8
2DLD Change Limit146162996.61022112.3
3Display Results99990.0303300.0
 (SQL Overall)178691997.06025310.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.