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

87 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
singular932756(None) 
cingular11256971cingular
lingular9407501lingular
singulars10305631singulars
angular838532_angular
cingula10327172cingula_
insular7138702_insular
ligular8348532li_gular
lingula8428802lingula_
lingulae9357032lingulae
pinnular1044432pinnular
simular938672si_mular
singularly1453232singularly
ungular836772_ungular
annular737693_annular
binocular1394603binocular
biovular1343603biovular
cannular1046283cannular
canular9310323can_ular
cingulate12238603cingulate
cingulum1342723cingulum
circular1247903circular
consular1038813consular
fibular12267973fi_bular
fistular1144253fistular
gular6314833___gular
ingulf10310353_ingul_f
ingulfs1134733_ingulfs
insulars8137323_insulars
jingler154311093jing_ler
jugular1534513_jugular
ligula7359673li_gula_
ligulae8308753li_gulae
ligulas8329173li_gulas
lingua7509913lingu_a_
linguae8398413lingu_ae
lingual8379083lingu_al
linguals9317223linguals
lingulate10368193lingulate
lunular736013lun_ular
mingler104213843ming_ler
pendular1144943pendular
piacular1246573piacular
pilular938203pi_lular
pinnula934913pinnula_
pinnulae1044183pinnulae
ranular739433ran_ular
regular838423_regular
saccular1246893saccular
sangar73617683sang__ar
scapular1245373scapular
secular92211533s_ecular
shingler12268633shing_ler
shinguard1442583shingu_ard
sigla64515203si_g_la_
signaler945453signaler
similar937853si_milar
simulars1047073si_mulars
sinful938803sinful__
sinfully1445613sinfully
singer74227313sing__er
single74520603sing_l_e
singled93914683sing_led
singles83520433sing_les
singlet84120113sing_let
singly104015853sing_l_y
singularity1552763singularity
singularize2152513singularize
sniggler10396113sniggler
spatular1044653spatular
specular12217613specular
spicular12238903spicular
spinula9257903spin_ula_
spinulae10276963spin_ulae
sporular1065223sporular
stipular1045843stipular
tegular836603_tegular
tingler83613343ting_ler
tissular843813tissular
titular737523ti_tular
triangular1162863triangular
undular837123_undular
ungula737603_ungula_
ungulae837313_ungulae
venular1037683ven_ular
vincula1246393vincula_
zonular1656493zon_ular

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.1601116818.8
2DLD Change Limit146162877.31019994.8
3Display Results87870.0332636.4
 (SQL Overall)178691877.50323815.9
 
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.