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

88 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
insulars813732(None) 
insular7138701insular_
instars7411132ins_tars
insulant849872insulant
insulants946912insulants
insularism1253722insularism
insularly1245322insularly
insulate8312842insulate
insulates9311842insulates
insulators1047262insulators
insulins848862insulins
insulters945882insulters
insults7268962insul_ts
insurers83710132insurers
singulars10305632singulars
angular838533angular_
annular737693annular_
ashlars10297063_ashlars
binoculars1463173binoculars
cingular11256973cingular_
circulars1346543circulars
consular1038813consular_
desugars1043373desugars
ensurers8279373ensurers
incurs83012283incu__rs
inducers11326953inducers
indulgers1143803indulgers
indulges1045263indulges
indulins958863indulins
indults8289493indul_ts
infusers11286143infusers
ingulfs1134733ingul_fs
inhalers1166643inhalers
inhaulers1263243inhaulers
inhumers1364823inhumers
injurers15286123injurers
inlays9389873in__lays
insculps1243393inscul_ps
inseams9307903ins_eams
insiders947763insiders
insnare748243ins_nare
insnares858083ins_nares
insofar1043543insofar_
insolate8311893insolate
insolates9311273insolates
insoles73516243insol_es
insouls737213insoul__s
inspans937803ins_pans
installs858923installs
instals7611713ins_tals
instar6310013ins_tar_
insularisms1352653insularisms
insularity1354523insularity
insulated10310713insulated
insulator948103insulator
insulin738483insul_in
insult62813673insul__t
insulted937193insulted
insulter836883insulter
insurant8411413insurant
insurants947643insurants
insure63416603insu__re
insureds9277613insureds
insurer73312803insurer_
insures73117263insu_res
inulase739413in_ulase
inulases838763in_ulases
inulins7311493in_ulins
invars9310003in__vars
isobars936593i_sobars
issuers746123issu_ers
jugulars1643233jugulars
lingular9407503lingular_
modulars1165833modulars
nonsugars1043703nonsugars
oculars948363_oculars
pinnular1044433pinnular_
regulars936253regulars
seculars10219393seculars
simulars1047073simulars
singular9327563singular_
sugars7312423__sugars
tissular843813tissular_
titulars845863titulars
undular837123undular_
ungular836773ungular_
unswears1144023unswears
uvulars1044413_uvulars

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.1561145455.1
2DLD Change Limit146162887.12320519.7
3Display Results88880.0332666.7
 (SQL Overall)178691887.31224438.0
 
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.