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

62 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
insulators104726(None) 
insulator948101insulator_
incubators1495252incubators
inculcators1544182inculcators
inflators1257712in_flators
inhalators1344932inhalators
inoculators1345632inoculators
insufflators1851602insufflators
insulars8137322insula__rs
insulates9311842insulat_es
insulations11310232insulations
insulters945882insul_ters
isolators947512i_solators
undulators1144832undulators
adulators1048063_adulators
ambulators1445473ambulators
circulators1545733circulators
consultors1286403consul_tors
desolators1146283desolators
emulators1148183_emulators
fabulators1544693fabulators
idolators1046283i_dolators
immolators1444273immolators
incubator1395723incubator_
incubatory1794243incubatory
inculcator1444633inculcator_
inculpatory1853353inculpatory
indagators1244153indagators
indicators1348613indicators
inductors1246223indu_ctors
inflaters1247543in_flaters
inflator1158033in_flator_
inhalator1245053inhalator_
initiators10127313initiators
innovators1344143innovators
inoculator1246323inoculator_
insinuators1154143insinuators
insolates9311273insolat_es
insolations1149183insolations
inspectors1444933inspectors
inspirators1345553inspirators
instigators1245923instigators
insufflator1751793insufflator_
insulants946913insula_nts
insular7138703insula__r_
insulate8312843insulat__e
insulated10310713insulat_ed
insulating1139263insulating
insulation10311663insulation
insulter836883insul_ter_
insults7268963insul_t__s
inundators11114383inundators
isolator847533i_solator_
modulators1345333modulators
peculators1486983peculators
postulators1345253postulators
regulators1146503regulators
simulators1246103simulators
tabulators1245293tabulators
tubulators1244513tubulators
undulator1045393undulator_
undulatory1444083undulatory

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 Filter1786911406030.410435831.7
2DLD Change Limit140603625.81024200.2
3Display Results62620.0331878.8
 (SQL Overall)178691626.25328576.8
 
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.