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

91 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
assigner94485(None) 
assigned1044631assigned
assignee944841assignee
assigners1044411assigners
assignor942991assignor
aligner8108312a_ligner
assign736782assign__
assignat945682assignat
assignees1043502assignees
assignors1043242assignors
assigns836192assign_s
assister836752assister
cosigner1135952cosigner
designer1036542designer
resigner937792resigner
signer74015632__signer
actioner1048663actioner
aginner844663a_ginner
aliener71011193a_liener
aligned9128553a_ligned
aligners9117573a_ligners
aliner65621983a_li_ner
armiger1036253armig_er
arraigner1092973arraigner
arsine64021043arsi_ne_
arsines73518813arsi_nes
ashier94714833ashi__er
aspirer967903aspi_rer
assailer844823assailer
assayer1035573ass_ayer
assenter867703assenter
asserter877573asserter
assignats1044003assignats
assigning1144673assigning
assignment1353893assignment
assisted936233assisted
assisters936353assisters
assistor844823assistor
assize1538633assi_ze_
assizes1638453assi_zes
assorter866673assorter
assuager944343assuager
assumer965363ass_umer
assurer767793ass_urer
bassinet10312843bassi_net
cassine93817283cassi_ne_
cassines103116613cassi_nes
consigner1246633consigner
cosigned1235723cosigned
cosigners1245133cosigners
designed1136943designed
designee1087753designee
designers1136003designers
eloigner943423eloigner
fashioner15114323fashioner
feigner1135593_feigner
gassier83812573gassi__er
insigne837673insigne_
maligner11115333maligner
massager1136873massag_er
massier93615223massi__er
missioner1147883missioner
nonsigner1045363nonsigner
ossifier111196273ossifier
passenger1243413passenger
reassigned1243603reassigned
resigned1038863resigned
resigners1036863resigners
sassier73413233sassi__er
seigneur942933_seigneur
seiner64622483_sei_ner
shiner93820873_shi_ner
sigher103813703__sigher
signed83413753__signed
signee73617233__signee
signers84714443__signers
signet73621153__signet
signor73510353__signor
singer74227313__singer
sinner64320603__sinner
skinner11348093_skinner
slinger83413833_slinger
snigger9328373_snigger
soigne74310033_soigne_
soignee8279133_soignee
spinner93912263_spinner
stinger84314683_stinger
swigger12338453_swigger
swinger113812563_swinger
unassigned1262473unassigned
unsigned1037563unsigned

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 Filter1786911461620.406440125.6
2DLD Change Limit146162917.59319249.6
3Display Results91910.0461978.3
 (SQL Overall)178691918.04522211.4
 
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.